Congratulations, you've almost reached
the end of this capstone course and your database engineering journey. In this final module you'll need to
demonstrate your knowledge in a peer review exercise and graded assessment. But before you begin let's recap the task
that you helped Little Lemon to complete in this course. These tasks include setting up their
database in MySQL workbench using a my sequel server instance. Creating an entity relationship or
Diagram and implementing it in MySQL workbench and
committing the project using Git. You also help Little Lemon to create sales
reports from the data in their database, build a table booking system, generate data insights using data
analytics and create a database client. Let's take a few minutes
to review the processes and tools that you use to
complete these tasks. In the first set of tasks,
you help Little Lemon to build a relational database system by designing
a well structured entity model or Diagram that conformed to the three
fundamental normal forms. You design the Diagram
using MySQL Workbench, a unified visual tool used for
database modeling and management. The key feature of MySQL workbench
that you made use of is its ability to transform your data model in a physical
database schema in a MySQL server. Once you created
the Little Lemon database, you then committed your project using
Git the version control system. You also made use of GitHub to
store your Git repositories. Your next task involved creating sales
reports from the data in the Little Lemon database. You created these sales reports using
database queries, procedures and prepared statements. Let's take a quick look at some of the
different types of queries that you used. You use virtual tables to make use of
data that exists in other tables and to simplify data access inquiries. You also made use of different kinds
of join clauses to link records of data between one or
more tables based on a common column. You helped Little Lemon to use stored
procedures to create reusable code that they could invoke and
execute as required. And you also relied on prepared statements
that could be compiled just once and then used repeatedly. Another task you assisted Little Lemon
with involved building a table booking system in their database that they could
use to keep track of guests visiting the restaurant. This task mainly consisted of using
SQL queries and transactions. Let's review some examples of the SQL
queries and transactions that you used. You created data using
insert into statements. You change data in the database
using update statements. You also deleted or
dropped data using delete statements, and finally you read your data using
read queries like select statements. You also made use of triggers to store
a set of actions in the form of a stored program that you could then invoke
automatically when certain events occurred. Once you were confident
that your code was correct, you committed your progress to
Git an enacted version control. In the next task, you help Little Lemon
use their data to generate business insights you carried out this task using
Tableau, the data visualization tool. Let's review the process steps that
you followed, to complete this task, you first connected your
data sources to Tableau. You then prepared your data for analysis
and focused on the most relevant data. The next step was to create
a visualization of your data using its Ui elements. Finally you use Tableau, to produce interactive real time data
visualizations in the form of dashboards. These process steps, helped to
provide clear and relevant answers, to Little Lemons important
business questions. Your final task was to help Little Lemon
create a database client so that they could interact with their
database using a python base application. To begin, you first identified which version of
python was running on your machine. Once you confirm that you were running
the most recent iteration of python, you installed the Jupyter IDE
to run your code on. You then opened a new instance
of the Jupyter notebook and used it to connect Python to
the Little Lemon MySQL database. You established this connection using
the Python library, MySQL connector and the pip software package. Once you set up your Python environment, you then began working
with your database client. So,now that you've recap
the tasks you completed, it's time to begin
the peer review project. Don't worry you've worked
hard to make it this far, so I'm sure you'll do your very best
in the project, best of luck.